How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips]

Posted by The Geek on How to geek See other posts from How to geek or by The Geek
Published on Wed, 28 Apr 2010 17:00:46 +0000 Indexed on 2010/04/28 17:13 UTC
Read the original article Hit count: 357

Filed under:

Have you ever wanted to fill an entire row or column with a series of values? If you’re an Excel user, you can do the same thing in Google Docs. If you haven’t used either, here’s the quick way to do it.

Just type in a couple of numbers in sequence… 1 2 3 works pretty well. You could also put them across a row instead of down a column.

image

Then move your mouse over the dot in the corner until the pointer changes, then just drag it downward (or if you are filling a row instead, you can drag it to the right).

image

Let go of the mouse, and your data will be automatically filled in.

image

You could also make it skip by 1 instead, like 2 4 6 8, etc…

image

It all works the same way. Sadly there’s no really advanced options like Excel has, but for most uses, this is good enough. Also, we’re aware this is a very simple tip for most of you, but we’re trying to help the beginners out as well!


Got an opinion to share? Click here to join the discussion

Similar Articles Productive Geek Tips
Latest Software Reviews Tinyhacker Random Tips


© How to geek or respective owner

Related posts about Google Docs